#SQL Basics

[technicalfika]

Unlocking Your Future: How to Become an SQL Engineer at Top Tech Companies

As a college student with aspirations of landing your dream job at a top tech giant company, becoming an SQL Engineer can open the doors to a data-driven and fulfilling career. SQL (Structured Query Language) is an essential skill in the tech industry, enabling professionals to manage and analyze vast amounts of data efficiently. In this comprehensive guide, we will explore the key steps to…

[12neonlit-stage]

I go by no pronouns but not as in my name, more so like my pronouns are an undefined variable in shell coding

[simknowsstuff]

Eeaaaoughhh

i just fucking

Did so much rearangement in programing

In ASYNCHRONOUS PROGRAMMING

AND IT WORKED

this is like my magnum opus as a programmer, i made decisions that weren't fatally wrong and was able to move stuff around for neatness and hoaly shit

Tmmrw im gonna work on mostly blobs and higher order sql data (i somehow gotta store messages between users and like other stuff and aaaaaaaaadhhfjdjd ) so that I can finally make the website part exist

[small-basic-programming]

Top 10 - The Best Programming Languages ...

https://www.tiobe.com/tiobe-index/

Ranking of the 10 most popular programming resp. script languages according to TIOBE programming community index:

Python

C

C++

Java

C#

JavaScript

PHP

Visual Basic

SQL

Assembler

Post #188: Tiobe, Index of the 10 best programming resp. script languages in November 2023.

[fazedlight]

i feel like how it handles local will be the question - utc/gmt inherently doesn’t have dst i thought? (could totally be wrong or misunderstanding a programming intricacy!!!)

You're right that UTC doesn't have DST - but sometimes systems use a mix of time paradigms, which can lead to hilarious results.

AO3 actually had a bug like this, where if you posted between midnight & 5am UTC, the post would behave as though the date was set manually (and not appear at the top of the search results).

It turns out that OTW has a public jira, and so we can see a ticket for this. The AO3 servers use UTC, but their Rails code for parsing posts was using Eastern/New York... leading to the weird posting behavior.

So I figure I may as well have the extra test in there, just in case something really weird is going on with mixed timezones or maybe other unknown flags 🤣 I don't expect it to be a useful test, but it's not much effort to add, and you never know when an odd test will catch something!

[seniordba]

TIOBE Index for May 2023 - Which Programming Language is Most Popular?

Have you seen the latest TIOBE rankings report? The TIOBE Programming Community index is an indicator of the popularity of programming languages. The index is updated once a month. The ratings are based on the number of skilled engineers world-wide, courses and third-party vendors. Popular search engines such as Google, Bing, Yahoo!, Wikipedia, Amazon, YouTube and Baidu are used to calculate the…

[nommedtail]

i think using ch@tgpt or copiIot to just. get answers to how to do things skips a part of the learning process that's so important

crawling through several links and forums of people offering solutions

[m-school0730]

高還元SESとうわさの『株式会社中野エージェント』の実態をまとめました。

[sillimancer]

it's nearly four in the dang morning and I have a welfare phone call somewhere between 9 and 12 but I'm so balls deep in this SQL project I'm doing for school that I'm seriously considering just staying up all night so I can finish it

[programmingassignmenthelperbd]

"Save this & read Caption for details!

For take our services contact with us Whatsapp/Telegram:+8801772432396 Email 1:academiccourseworkservices@gmail.com Email 2:programmingassignmentsservices@gmail.com

we provide all type of academic services.such as: 🟩PHP 🟩Python 🟩C 🟩C++ 🟩Java 🟩C# 🟩Visual Basic .NET 🟩JavaScript 🟩SQL 🟩Assembly language 🟩R 🟩Go 🟩Classic Visual Basic 🟩MATLAB 🟩Swift 🟩Delphi/Object Pascal 🟩Ruby 🟩Perl 🟩Objective-C 🟩Rust 🟩Scratch 🟩SAS 🟩Kotlin 🟩Julia 🟩Lua 🟩Fortran 🟩COBOL 🟩Lisp 🟩(Visual) FoxPro 🟩Ada 🟩Dart 🟩Scala 🟩Prolog 🟩D 🟩PL/SQL 🟩Bash 🟩Powershell 🟩Haskell 🟩Logo 🟩Transact SQL

📌 Save this and Share with others!

View this post on Instagram

A post shared by ProgrammingAssignmentHelperBd (@programmingassignmenthelperbd)

[docstaeducation]

Mastering Basic SQL A Comprehensive Course for Beginners | Docsta Learn 

Unlock the power of SQL with our Basic SQL course designed for beginners. Learn essential concepts, syntax, and commands to manipulate databases effectively. Gain hands-on experience through practical exercises and real-world examples. Start your journey to becoming a proficient SQL developer today! Check here once: https://docsta.com/course/basic-sql

[siyacarla]

The Basics of SQL for Backend Developers

SQL (Structured Query Language) plays a crucial role in backend development, but what makes it so important? In this guide, we’ll explore the basics of SQL for backend developers. We’ll begin with an overview of relational databases and the SQL language, which is used to interact with them.  Relational databases provide a structured and efficient way to store and retrieve data, and SQL serves as…

[niconiconwo]

Like bro. Inventory system? SQL. Invoicing and transactions? SQL. Purchasing system? Bam, SQL. Ledger etc? More SQL. Scheduling and HR? S Q L B A B Y.

So to get a good desk job developing it's probably wise to learn any worthwhile language (C, Python, JS, PHP) and then SQL.

[tpointtechblog]

Top 30 SQL Interview Questions and Answers for Fresher and Experienced

Sure! Here are the top 30 SQL interview questions and answers for both fresher and experienced candidates:

What is SQL? SQL stands for Structured Query Language, and it is a programming language designed for managing and manipulating relational databases. What are the different types of SQL statements? There are four main types of SQL statements: Data Manipulation Language (DML) statements…

[komaedalovemail]

komaedas have you tried straw.page?

(i hope you don't mind if i make a big ollllle webdev post off this!)

i have never tried straw.page but it looks similar to carrd and other WYSIWYG editors (which is unappealing to me, since i know html/css/js and want full control of the code. and can't hide secrets in code comments.....)

my 2 cents as a web designer is if you're looking to learn web design or host long-term web projects, WYSIWYG editors suck doodooass. you don't learn the basics of coding, someone else does it for you! however, if you're just looking to quickly host images, links to your other social medias, write text entries/blogposts, WYSIWYG can be nice.

toyhouse, tumblr, deviantart, a lot of sites implement WYSIWYG for their post editors as well, but then you can run into issues relying on their main site features for things like the search system, user profiles, comments, etc. but it can be nice to just login to your account and host your information in one place, especially on a platform that's geared towards that specific type of information. (toyhouse is a better example of this, since you have a lot of control of how your profile/character pages look, even without a premium account) carrd can be nice if you just want to say "here's where to find me on other sites," for example. but sometimes you want a full website!

---------------------------------------

neocities hosting

currently, i host my website on neocities, but i would say the web2.0sphere has sucked some doodooass right now and i'm fiending for something better than it. it's a static web host, e.g. you can upload text, image, audio, and client-side (mostly javascript and css) files, and html pages. for the past few years, neocities' servers have gotten slower and slower and had total blackouts with no notices about why it's happening... and i'm realizing they host a lot of crypto sites that have crypto miners that eat up a ton of server resources. i don't think they're doing anything to limit bot or crypto mining activity and regular users are taking a hit.

↑ page 1 on neocitie's most viewed sites we find this site. this site has a crypto miner on it, just so i'm not making up claims without proof here. there is also a very populated #crypto tag on neocities (has porn in it tho so be warned...).

---------------------------------------

dynamic/server-side web hosting

$5/mo for neocities premium seems cheap until you realize... The Beautiful World of Server-side Web Hosting!

client-side AKA static web hosting (neocities, geocities) means you can upload images, audio, video, and other files that do not interact with the server where the website is hosted, like html, css, and javascript. the user reading your webpage does not send any information to the server like a username, password, their favourite colour, etc. - any variables handled by scripts like javascript will be forgotten when the page is reloaded, since there's no way to save it to the web server. server-side AKA dynamic web hosting can utilize any script like php, ruby, python, or perl, and has an SQL database to store variables like the aforementioned that would have previously had nowhere to be stored.

there are many places in 2024 you can host a website for free, including: infinityfree (i use this for my test websites :B has tons of subdomains to choose from) [unlimited sites, 5gb/unlimited storage], googiehost [1 site, 1gb/1mb storage], freehostia [5 sites/1 database, 250mb storage], freehosting [1 site, 10gb/unlimited storage]

if you want more features like extra websites, more storage, a dedicated e-mail, PHP configuration, etc, you can look into paying a lil shmoney for web hosting: there's hostinger (this is my promocode so i get. shmoney. if you. um. 🗿🗿🗿) [$2.40-3.99+/mo, 100 sites/300 databases, 100gb storage, 25k visits/mo], a2hosting [$1.75-12.99+/mo, 1 site/5 databases, 10gb/1gb storage], and cloudways [$10-11+/mo, 25gb/1gb]. i'm seeing people say to stay away from godaddy and hostgator. before you purchase a plan, look up coupons, too! (i usually renew my plan ahead of time when hostinger runs good sales/coupons LOL)

here's a big webhost comparison chart from r/HostingHostel circa jan 2024.

---------------------------------------

domain names

most of the free website hosts will give you a subdomain like yoursite.has-a-cool-website-69.org, and usually paid hosts expect you to bring your own domain name. i got my domain on namecheap (enticing registration prices, mid renewal prices), there's also porkbun, cloudflare, namesilo, and amazon route 53. don't use godaddy or squarespace. make sure you double check the promo price vs. the actual renewal price and don't get charged $120/mo when you thought it was $4/mo during a promo, certain TLDs (endings like .com, .org, .cool, etc) cost more and have a base price (.car costs $2,300?!?). look up coupons before you purchase these as well!

namecheap and porkbun offer something called "handshake domains," DO NOT BUY THESE. 🤣🤣🤣 they're usually cheaper and offer more appealing, hyper-specific endings like .iloveu, .8888, .catgirl, .dookie, .gethigh, .♥, .❣, and .✟. I WISH WE COULD HAVE THEM but they're literally unusable. in order to access a page using a handshake domain, you need to download a handshake resolver. every time the user connects to the site, they have to provide proof of work. aside from it being incredibly wasteful, you LITERALLY cannot just type in the URL and go to your own website, you need to download a handshake resolver, meaning everyday internet users cannot access your site.

---------------------------------------

hosting a static site on a dynamic webhost

you can host a static (html/css/js only) website on a dynamic web server without having to learn PHP and SQL! if you're coming from somewhere like neocities, the only thing you need to do is configure your website's properties. your hosting service will probably have tutorials to follow for this, and possibly already did some steps for you. you need to point the nameserver to your domain, install an SSL certificate, and connect to your site using FTP for future uploads. FTP is a faster, alternative way to upload files to your website instead of your webhost's file upload system; programs like WinSCP or FileZilla can upload using FTP for you.

if you wanna learn PHP and SQL and really get into webdev, i wrote a forum post at Mysidia Adoptables here, tho it's sorted geared at the mysidia script library itself (Mysidia Adoptables is a free virtual pet site script, tiny community. go check it out!)

---------------------------------------

file storage & backups

a problem i have run into a lot in my past like, 20 years of internet usage (/OLD) is that a site that is free, has a small community, and maybe sounds too good/cheap to be true, has a higher chance of going under. sometimes this happens to bigger sites like tinypic, photobucket, and imageshack, but for every site like that, there's like a million of baby sites that died with people's files. host your files/websites on a well-known site, or at least back it up and expect it to go under!

i used to host my images on something called "imgjoe" during the tinypic/imageshack era, it lasted about 3 years, and i lost everything hosted on there. more recently, komaedalovemail had its webpages hosted here on tumblr, and tumblr changed its UI so custom pages don't allow javascript, which prevented any new pages from being edited/added. another test site i made a couple years ago on hostinger's site called 000webhost went under/became a part of hostinger's paid-only plans, so i had to look very quickly for a new host or i'd lose my test site.

if you're broke like me, looking into physical file storage can be expensive. anything related to computers has gone through baaaaad inflation due to crypto, which again, I Freaquing Hate, and is killing mother nature. STOP MINING CRYPTO this is gonna be you in 1 year

...um i digress. ANYWAYS, you can archive your websites, which'll save your static assets on The Internet Archive (which could use your lovely donations right now btw), and/or archive.today (also taking donations). having a webhost service with lots of storage and automatic backups can be nice if you're worried about file loss or corruption, or just don't have enough storage on your computer at home!

if you're buying physical storage, be it hard drive, solid state drive, USB stick, whatever... get an actual brand like Western Digital or Seagate and don't fall for those cheap ones on Amazon that claim to have 8,000GB for $40 or you're going to spend 13 days in windows command prompt trying to repair the disk and thenthe power is gong to go out in your shit ass neighvborhood and you have to run it tagain and then Windows 10 tryes to update and itresets the /chkdsk agin while you're awayfrom town nad you're goig to start crytypting and kts just hnot going tot br the same aever agai nikt jus not ggiog to be the saeme

---------------------------------------

further webhosting options

there are other Advanced options when it comes to web hosting. for example, you can physically own and run your own webserver, e.g. with a computer or a raspberry pi. r/selfhosted might be a good place if you're looking into that!

if you know or are learning PHP, SQL, and other server-side languages, you can host a webserver on your computer using something like XAMPP (Apache, MariaDB, PHP, & Perl) with minimal storage space (the latest version takes up a little under 1gb on my computer rn). then, you can test your website without needing an internet connection or worrying about finding a hosting plan that can support your project until you've set everything up!

there's also many PHP frameworks which can be useful for beginners and wizards of the web alike. WordPress is one which you're no doubt familiar with for creating blog posts, and Bluehost is a decent hosting service tailored to WordPress specifically. there's full frameworks like Laravel, CakePHP, and Slim, which will usually handle security, user authentication, web routing, and database interactions that you can build off of. Laravel in particular is noob-friendly imo, and is used by a large populace, and it has many tutorials, example sites built with it, and specific app frameworks.

---------------------------------------

addendum: storing sensitive data

if you decide to host a server-side website, you'll most likely have a login/out functionality (user authentication), and have to store things like usernames, passwords, and e-mails. PLEASE don't launch your website until you're sure your site security is up to snuff!

when trying to check if your data is hackable... It's time to get into the Mind of a Hacker. OWASP has some good cheat sheets that list some of the bigger security concerns and how to mitigate them as a site owner, and you can look up filtered security issues on the Exploit Database.

this is kind of its own topic if you're coding a PHP website from scratch; most frameworks securely store sensitive data for you already. if you're writing your own PHP framework, refer to php.net's security articles and this guide on writing an .htaccess file.

---------------------------------------

but. i be on that phone... :(

ok one thing i see about straw.page that seems nice is that it advertises the ability to make webpages from your phone. WYSIWYG editors in general are more capable of this. i only started looking into this yesterday, but there ARE source code editor apps for mobile devices! if you have a webhosting plan, you can download/upload assets/code from your phone and whatnot and code on the go. i downloaded Runecode for iphone. it might suck ass to keep typing those brackets.... we'll see..... but sometimes you're stuck in the car and you're like damn i wanna code my site GRRRR I WANNA CODE MY SITE!!!

↑ code written in Runecode, then uploaded to Hostinger. Runecode didn't tell me i forgot a semicolon but Hostinger did... i guess you can code from your webhost's file uploader on mobile but i don't trust them since they tend not to autosave or prompt you before closing, and if the wifi dies idk what happens to your code.

---------------------------------------

ANYWAYS! HAPPY WEBSITE BUILDING~! HOPE THIS HELPS~!~!~!

-Mod 12 @eeyes

[transgenderer]

after ~3 months of agony after the first rejections came in, i got accepted to exactly one phd program. at least according to the guy, i got their very last spot. so. that's very weird, as an experience. i accepted so. i will be living in NYC come july. im...excited? it doesnt feel real. i had fully accepted not getting in anywhere and dropping out of grad school (becuase i dont like it here. along basically every axis). i learned the basics of SQL, i rewrote my resume, i was fully gearing up for the job search. very weird experience. yay, i think. thanks to reggie for suggesting i apply somewhere else. i will be in grad school forever. nothing ever happens